package org.csu.mypetstore.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.csu.mypetstore.domain.PO.LineItem;

public interface LineItemMapper extends BaseMapper<LineItem> {

//    @Select("SELECT ORDERID, LINENUM AS lineNumber, ITEMID, QUANTITY, UNITPRICE" +
//            " FROM LINEITEM WHERE ORDERID = #{orderId}")
//    public List<LineItem> getLineItemsByOrderId(int orderId);
//
//    @Insert("INSERT INTO LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, UNITPRICE) " +
//            "VALUES (#{lineItem.orderId},#{lineItem.lineNumber},#{lineItem.itemId},#{lineItem.quantity},#{lineItem.unitPrice})")
//    public void insertLineItem(@Param("lineItem") LineItem lineItem);
}
